﻿CREATE TABLE [dbo].[States] (
    [StatePK]          UNIQUEIDENTIFIER NOT NULL,
    [Name]             NVARCHAR (200)   NOT NULL,
    [Order]            INT              NOT NULL,
    [WorkflowFK]       UNIQUEIDENTIFIER NOT NULL,
    [IsCompletedState] BIT              NOT NULL,
    [IsCancelledState] BIT              NOT NULL,
    [CreatedDate]      DATETIME         NOT NULL,
    [CreatedBy]        UNIQUEIDENTIFIER NOT NULL
);

